UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4yACsqrwMZFIcAKqavd40/fs/iIsDjWkVoIi9Xrkw9E='
WHERE
key_id = '8aea087de7f70705881196a908616f15f5b936ec5fb2a620ba50a67057e823b7'
AND (
token = '4yACsqrwMZFIcAKqavd40/fs/iIsDjWkVoIi9Xrkw9E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)