UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '7iMkBdR1ZL4mvZUCs4wt/AlimNZIz2+x6Yz/Bun5sM8=' 
WHERE 
  key_id = '851545ba6c290e0ab2540664245400992d86cb1a9d85123142b22f5ae8ed7204' 
  AND (
    token = '7iMkBdR1ZL4mvZUCs4wt/AlimNZIz2+x6Yz/Bun5sM8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021