UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Yz2oOiW0/Hywp0qg6SZ8uKnudiAGm4uRPnDpPFGWRr8=' 
WHERE 
  key_id = '3ad4757c59f2d33f3bbcb7d20a0ce2497aa338a3cd170716a669b748303c9100' 
  AND (
    token = 'Yz2oOiW0/Hywp0qg6SZ8uKnudiAGm4uRPnDpPFGWRr8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032