UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nQVLQ2T7cASshUXhADRodb6mhOiF9ihf78c1YOV8NhE='
WHERE
key_id = '6ae21468f7415a8f5c1f100a4a2d8d7dc787563291310205eef0cc93b1721591'
AND (
token = 'nQVLQ2T7cASshUXhADRodb6mhOiF9ihf78c1YOV8NhE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)