UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JchWwTRAm/e5JSRODeCU+bHrMvHY4msRTQMDFW0JbEM='
WHERE
key_id = 'bc5604ce317e9ea44a8a1c23b2421992b6abe6744de25853f33029188aab028a'
AND (
token = 'JchWwTRAm/e5JSRODeCU+bHrMvHY4msRTQMDFW0JbEM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)