UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CQi84COFrQt71NnrSYetFWxthfNiSYE4iBqno33RCPI='
WHERE
key_id = 'a40fd3557fb74a2bc689088f136712c62ad0963488957bb16f59fc72cf954806'
AND (
token = 'CQi84COFrQt71NnrSYetFWxthfNiSYE4iBqno33RCPI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)