UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ea5EIX5amtDQej7ve+QH+csiCwE2XHf8+c7mRAh1rOA='
WHERE
key_id = 'c3af53f8b0b56057ac9bca4c9fef2ad637101c93204b90d91c6dd77ea97501de'
AND (
token = 'ea5EIX5amtDQej7ve+QH+csiCwE2XHf8+c7mRAh1rOA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)