UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nU8xFUX1L7owF7ZiQqqH5Un+2B3s3MiZEKIDNI16tU0='
WHERE
key_id = 'a101d00af7d14de5aac2f99bbd11f3383de99386f0198afc5c9807b121e09a9e'
AND (
token = 'nU8xFUX1L7owF7ZiQqqH5Un+2B3s3MiZEKIDNI16tU0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)