UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'zIxa+McubAut894QCnaeg9fJELHn5C0BfJ+WStl2Zl8=' 
WHERE 
  key_id = 'e2c65604c1d462d3a7ee1cff6f7e93d2a83a1f5c7b09bf71d3bb2f7ce8b1ca55' 
  AND (
    token = 'zIxa+McubAut894QCnaeg9fJELHn5C0BfJ+WStl2Zl8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023