UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '9ax9geVn8ppavE5SRVzPUefzYY1fMXN9qFVX6TiGswc=' 
WHERE 
  key_id = '38d891f47685d1e87a5f87cd6df5f73ac2b2a33a12fceede952af2e9ada38edd' 
  AND (
    token = '9ax9geVn8ppavE5SRVzPUefzYY1fMXN9qFVX6TiGswc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021