UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'rdpYc6yYP80+Qpy0W6WY6pYtq2tBMC0YiQj6TrqSnC8=' 
WHERE 
  key_id = '63feb0aa6d339da4deb33565b58bbcbce6cef3d1ba82cbcd12ff8a4b0c5dfc85' 
  AND (
    token = 'rdpYc6yYP80+Qpy0W6WY6pYtq2tBMC0YiQj6TrqSnC8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00046