UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BxrK27vpov8DTZ6Z6RBCX9HAI0/Dbndh8x9Peuzme9M='
WHERE
key_id = '7b50505e7ae17de94416a3eaece2d450861860f32e49f2a0272bf69f7987cfe2'
AND (
token = 'BxrK27vpov8DTZ6Z6RBCX9HAI0/Dbndh8x9Peuzme9M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)