UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mBYc2cc+pU4rwt6eOnC5nN9y7QVaalORPCpxAgAl124='
WHERE
key_id = 'd1ed4aa69611da120239696f0ae706d106fd697b1ef0fb293608f77a48964a06'
AND (
token = 'mBYc2cc+pU4rwt6eOnC5nN9y7QVaalORPCpxAgAl124='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)