UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'viOg1sPH1Haeh2H9Rmhq33c73S4Czzg3tsg2pz47Kmg='
WHERE
key_id = '8e66aa1f774374504a485aa968be17aaa9f170b5c7826b6ff7fd7c643e22ba0c'
AND (
token = 'viOg1sPH1Haeh2H9Rmhq33c73S4Czzg3tsg2pz47Kmg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)