UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'hHVrg26zLNFwIw48vFG+sQuN2Qhmo9tR+3OQe5GT6ME=' 
WHERE 
  key_id = '3ea9124eeec8cda76d1c0aaddc8196fb0489e619e302f48f0dae3d2ac270c549' 
  AND (
    token = 'hHVrg26zLNFwIw48vFG+sQuN2Qhmo9tR+3OQe5GT6ME=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00038