UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'hGo/x1f1vEgDPVkR7qtQ8Qwzg6rc4xNOvCLiBBcGvmc=' 
WHERE 
  key_id = '9d8ca4fc11eaf2392e82d24c916d7fb2bf7aea7574a716e100c377d7abfd63c4' 
  AND (
    token = 'hGo/x1f1vEgDPVkR7qtQ8Qwzg6rc4xNOvCLiBBcGvmc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00040