UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zrFMsY4kXpdqhAfg6l1vm8KaFncy60bnFEWB1EKDJgw='
WHERE
key_id = '94c52aa60dd2a3cc56d23ff6810f7510ee4aa1943c7c2dc791d75d94df2b167e'
AND (
token = 'zrFMsY4kXpdqhAfg6l1vm8KaFncy60bnFEWB1EKDJgw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)