UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XouSh7WUwRF9nUL2zDPxAm6gc7HOehX9LACUtpk6PEU='
WHERE
key_id = '12c5772a92a0787a19adbae2d3948ad326b3ab384b9a266a857e011acd8c42a2'
AND (
token = 'XouSh7WUwRF9nUL2zDPxAm6gc7HOehX9LACUtpk6PEU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)