UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xZyt8zJQhmbM848+jIYy6zYW58Vftk2rfoohphaNtUc='
WHERE
key_id = 'ac7f904abd5e41e65dd50849f657ea4c0143848c600cd42fe996d6a8b3fdb54d'
AND (
token = 'xZyt8zJQhmbM848+jIYy6zYW58Vftk2rfoohphaNtUc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)