UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sQGiNrhgJLRlfbFW6RLTefA2PqLVhUVM6/m5NA2UGus='
WHERE
key_id = '861a0f2e66bc00ae47fd3ae901ceec86336104d45a5a79575bc64105d7270dec'
AND (
token = 'sQGiNrhgJLRlfbFW6RLTefA2PqLVhUVM6/m5NA2UGus='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)