UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nQPR7sySXyM/+ttBJxT7Tw7TlMyabturedS8fcmUOhI='
WHERE
key_id = '107bf8488e08a949e2f83632ba217428306c3eee364cc18677f1c86b1703b696'
AND (
token = 'nQPR7sySXyM/+ttBJxT7Tw7TlMyabturedS8fcmUOhI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)