UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P5+Fwku0h9iUYrXOD3MUWcHXBMal9W7S8Y9Mo0hzlsE='
WHERE
key_id = 'cbead1e713253c78b3383dd163e1a0947563b52ee6932bd2586cea679d3fdf1b'
AND (
token = 'P5+Fwku0h9iUYrXOD3MUWcHXBMal9W7S8Y9Mo0hzlsE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)