UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C8/QBCc/U7Cpw7mjXQNgTbLcauU+5p9ZxIdD7zYoYRg='
WHERE
key_id = 'ea7b4ed12fbf1a24fbb9fd69b459327b9106d75b963fd4716b6de071865889c3'
AND (
token = 'C8/QBCc/U7Cpw7mjXQNgTbLcauU+5p9ZxIdD7zYoYRg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)