UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yK6mIhuDUN7A1uDLWc2F6GrhQe2BdCXtmRVU2sin7q8='
WHERE
key_id = '3f04bee7f80e6902ec98509aed6d5882a474b9aa6c517f94893df6f1b156dd60'
AND (
token = 'yK6mIhuDUN7A1uDLWc2F6GrhQe2BdCXtmRVU2sin7q8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)