UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6DRNxa8Uw7kvpY6imQi0gYlGu5Yf9U/2MZKptVMomaw='
WHERE
key_id = '7e6cef83ba75b3cc2a0560efc6130c330e46470d92c24e55b641a238ecddf3f2'
AND (
token = '6DRNxa8Uw7kvpY6imQi0gYlGu5Yf9U/2MZKptVMomaw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)