UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7Crvvmjl4acO7aFzlVXukJB8sUy4awBBDhTT4Jx5ogo='
WHERE
key_id = 'c633b3a57ecd1db3a75111357add4bd2ee6d1fae1212c7b33d3e9ef471e3172a'
AND (
token = '7Crvvmjl4acO7aFzlVXukJB8sUy4awBBDhTT4Jx5ogo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)