UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZEi6PlgHkV+dcywTsKb9S9LySnrH+iIm5N01DCYKDMg='
WHERE
key_id = '057aa7cea67ae76e427194eae921fdbc5573f57f70be7775b93407ac2352d0e8'
AND (
token = 'ZEi6PlgHkV+dcywTsKb9S9LySnrH+iIm5N01DCYKDMg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)