UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S8phak3msiyN/IOvTgepfJjO/HMHtH3mgVxHr2TcHk0='
WHERE
key_id = 'eb1dff7cb33e90d14007ae26355d6ae90d42eb4f7519398df00768c841c4c211'
AND (
token = 'S8phak3msiyN/IOvTgepfJjO/HMHtH3mgVxHr2TcHk0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)