UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'j5760RY5ZoqGANghquCwsPaOXdrDOUe9okesYnF28e8='
WHERE
key_id = '84abfd7100fc0354188cf3110fd339b1918ecba12766b69acd91bf087b840a75'
AND (
token = 'j5760RY5ZoqGANghquCwsPaOXdrDOUe9okesYnF28e8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)