UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'J4y9V7ieKgVITDed9z5BKWQuexuEiuN1iqT890eIBsM=' 
WHERE 
  key_id = 'e36bb3b7e9b2b10f9e02a429d44a38b13c2ca5d0dec6d90f06c470735024e52f' 
  AND (
    token = 'J4y9V7ieKgVITDed9z5BKWQuexuEiuN1iqT890eIBsM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00043