UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6YU25J7z1bSZBcm1P7tTU6RA3oQLdjioQK7/A+tv7ig='
WHERE
key_id = '47162946260eadf0ed500fb06b59a7782bebc73bd0e84dbfc5734282092bcdd2'
AND (
token = '6YU25J7z1bSZBcm1P7tTU6RA3oQLdjioQK7/A+tv7ig='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)