UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wZ0BAWe5u2cgO9T94QPe0dCfsWHzLfYvyMcrdd1fzVw='
WHERE
key_id = 'a57b10121cfb22a8847df174a82f1c653b5cb5c65e1c98a0f7664742b7096787'
AND (
token = 'wZ0BAWe5u2cgO9T94QPe0dCfsWHzLfYvyMcrdd1fzVw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)