UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'xlwGJ+OsEEc+yFgsX97/LGu91S5Wwx8e9KGRi13B00U=' 
WHERE 
  key_id = '2c80cb3b88c35fecc7c4a3cc5c2e4da52c7e4fa1563e0de1bb24e0e0e36ebf17' 
  AND (
    token = 'xlwGJ+OsEEc+yFgsX97/LGu91S5Wwx8e9KGRi13B00U=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021