UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J7SBiZbveXypZ7+GtsvLN/HuWQgFqj3jWJ65E45o0e8='
WHERE
key_id = '2b50cbbedbf491df1b12b952b36d112813f85afe84e7a5475d4c23064a0c3b49'
AND (
token = 'J7SBiZbveXypZ7+GtsvLN/HuWQgFqj3jWJ65E45o0e8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)